Release 10.1A: OpenEdge Development:
Progress 4GL Reference

GET-COLLATIONS function

The GET-COLLATIONS function returns a comma-delimited list of the collations either listed in convmap.cp or specified by the Conversion Map (-convmap) startup parameter for the specified code page.

Syntax 

GET-COLLATIONS ( codepage )

codepage

A code page name. If there are no collations for the specified code page, Progress returns the Unknown value (?).

Example

This procedure displays a list of the code pages available in memory for the current OpenEdge session and the collations available for each code page:

r-get.p 
DEF VARIABLE code-page-list AS CHARACTER.
DEF VARIABLE collation-list AS CHARACTER.
DEF VARIABLE i AS INTEGER.
DEF VARIABLE j AS INTEGER.

code-page-list = GET-CODEPAGES.

REPEAT i = 1 TO NUM-ENTRIES(code-page-list):
  DISPLAY ENTRY(i,code-page-list) FORMAT "x(19)" COLUMN-LABEL "Code Page"
    WITH DOWN FRAME a.
  collation-list = GET-COLLATIONS(ENTRY(i,code-page-list)).
  REPEAT j = 1 TO NUM-ENTRIES(collation-list):
    DISPLAY ENTRY(j,collation-list) FORMAT "x(19)" COLUMN-LABEL "Collation"
      WITH DOWN FRAME a.
    DOWN WITH FRAME a.
  END.
END.

See also

GET-CODEPAGES function

Copyright © 2005 Progress Software Corporation
 www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095